2016 Ben Evans resource contributor of the year with 8.5M downloads
With over 6.8 million downloads already, I am offering a wide range of resources for use throughout Primary and some secondary schools.
My main resources are - spelling, leveled SATs questions for maths and science, learning mats for science, English and maths. spreadsheets analysis grids, and games and activities for science, maths and Christmas.
Resources will continue to be added so keep checking back.
Paul
2016 Ben Evans resource contributor of the year with 8.5M downloads
With over 6.8 million downloads already, I am offering a wide range of resources for use throughout Primary and some secondary schools.
My main resources are - spelling, leveled SATs questions for maths and science, learning mats for science, English and maths. spreadsheets analysis grids, and games and activities for science, maths and Christmas.
Resources will continue to be added so keep checking back.
Paul
The Key objectives for year 1 in target trackers are mapped out here - when they are taught and the frequency. Useful for planning assessment opportunities and planning.
The Key objectives for years 1-6 in target tracker are mapped out here - when they are taught and the frequency during the Collins Maths scheme. Useful for planning assessment opportunities and planning.
Need a clear, consistent and easy to use system for assessing Year 2 Maths without levels?
Year 2 maths areas covered:
number and place value
fractions
statistics
geometry
addition
subtraction
multiplication
division
measurement
The series contain 233 short assessment tasks for every statement from year 1 to year 5. Assessment without levels is about continuous assessment but within a structured and robust system to ensure consistency of approach. These assessments can be done quickly, at any time and repeated as the children will not know the answers. They can be done as a class, a group or individually.
The number of assessments are as follows
Year 1 – 20
Year 2 – 34
Year 3 - 33
Year 4 – 44
Year 5 - 49
Year 6 - 53
To support teachers, I have provided:
• Answers for each sheet
• Colour coded year group sheets
• An overview of all the statements organised by mathematical area
• A guide on what stage to assess the children at. I have used beginning, working within and secure as statements but these can be adapted to your system
Simply enter the scores for each child for each question, their gender, SEN and PPg status and the spreadsheet will give you:
a breakdown of each question percentage
the percentage overall, boys and girls for each area - number, calculation, geometry, statistics, measurement and fractions, decimals and percentage
overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN
ideal for school and subject leaders as well as teacher analysis of strengths and areas for development
See the read me file for links to other year groups analysis spreadsheets
Enter each pupil’s details - name, gender, PPG and SEN status as well as their KS1 and KS2 SATs outcomes and this spreadsheet automatically calculates:
The prior attainment group (PAG) group for each child
individual, class and group pupil progress and attainment
calculates children’s attainment and progress based on their cohort, gender, PPG and SEN status
See pictures for how the data is shown.
what to do:
enter each child’s name, gender, PPG and SEn status to the pupil info tab only
Enter KS1 results (includes P levels)
Enter KS2 results scaled scores for maths and reading. For writing the following codes are accepted - GD, EXS, WTS, PKG, PKE, PKF, BLW, P8, P7, P6, P5, P4, P3ii, P3i, P2ii, P2i ,P1ii, P1i
From here the spreadsheet does the rest
Calculates the PAG for each child and from this, sets the targets in reading, writing and maths for each child, based on a R&W average and then a KS1 average - see attached DfE document for further guidance
Once the KS2 data is added, the spreadsheet calculates each child’s progress and this is reflected in a green or red formatting for easy reference
On the summary tab, progress scores are calculated for the whole cohort, boys, girls, disadvantaged and other, SEN support and no SEN. The percentage achieving the standard or higher for each of these groups as well as the percentages achieving RWM for each category. This is mirrored for the percentage of children achieving the higher standard in for each group and RWM. Finally, the average scaled scores are calculated for overall and each group.
In addition, you can enter your 2017 data for easy comparison.
Each sheet fits neatly onto an A4 sheet for use by governors, SLT or school ‘visitors’
UPDATE**
if you purchased an earlier version please see the alterations below
My apologies – I sent out an earlier version of the spreadsheets to you. It affects the boy/girl, disadvantaged and SEN progress for reading and maths only. It is easy to fix
On the summary tab, click in cell D7. The formula reads
=IFERROR(((SUMIF(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!C:C))/COUNTIFS(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!C:C,">10")-100),"")
where it is C:C this should be D:D and the -100 needs deleting (keep the brackets though)
This needs repeating for cells D8-D12
In maths, it is similar
=IFERROR(((SUMIF(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!I:I))/COUNTIFS(‘Pupil Info’!B:B,“male”,‘Ind Pupi Progress’!I:I,">10")-100),"")
The I:I needs altering to J:J and delete the -100 again for cells F7 to F12
Simply enter the scores for each child for each question, their gender, SEN and PPg status and the spreadsheet will give you:
a breakdown of each question percentage
the percentage overall, boys and girls for each area - number, calculation, geometry, statistics, measurement and fractions, decimals and percentage
overall percentages for each of these areas for gender, PPG, non PPG, SEN and non SEN
ideal for school and subject leaders as well as teacher analsysis of strengths and areas for development
Need a clear, consistent and easy to use system for assessing Year 5 Maths without levels?
Year 5 maths areas covered:
number and place value
fractions
statistics
geometry
addition
subtraction
multiplication
division
measurement
The series contain 233 short assessment tasks for every statement from year 1 to year 5. Assessment without levels is about continuous assessment but within a structured and robust system to ensure consistency of approach. These assessments can be done quickly, at any time and repeated as the children will not know the answers. They can be done as a class, a group or individually.
The number of assessments are as follows
Year 1 – 20
Year 2 – 34
Year 3 - 33
Year 4 – 44
Year 5 - 49
Year 6 - 53
To support teachers, I have provided:
• Answers for each sheet
• Colour coded year group sheets
• An overview of all the statements organised by mathematical area
• A guide on what stage to assess the children at. I have used beginning, working within and secure as statements but these can be adapted to your system
These 36 resources are based on the Collins maths scheme, but are easily transferable to any week’s learning as they are based on new expectations for each group.